How to: Change the front to back order of controls in a form.
Solution:
In the Form Design view, select the desired control(s) to change the front to back order. Select the 'Format' menu and select 'Bring To Front' or 'Send To Back'.
1) If the Database window is not activated, activate the Database window.
2) Click the 'Forms' tab in the Database window.
Forms tab
3) Select the desired form from the list box. (The selected form is highlighted.)
4) Click 'Design'. (The selected form appears in Design view, and the floating Toolbox appears.)
5) Select the desired control to change. (Handles appear around the selected control.)
6) Do one of the following:
a) Select the 'Format' menu and select 'Bring To Front'.
b) Select the 'Format' menu and select 'Send To Back'.
7) Repeat steps 5) and 6) for each control.
8) Select the 'File' menu and select 'Save' to save the form.